<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
 "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<title>ry-vue-v3.8.6</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="date" content="Fri, 22 Sep 2023 10:35:08 +0800">
	<meta name="generator" content="MySQL-Front 6.1  (Build 1.26)">
	<style type="text/css"><!--
		body {font-family: Arial,Helvetica,sans-serif; font-size: 12px;}
		h1 {font-size: 18px; text-decoration: bold;}
		h2 {font-size: 16px; text-decoration: bold;}
		h3 {font-size: 14px; text-decoration: bold;}
		th,
		td {font-size: 12px; border-color: #000000; border-style: solid; border-width: 1px; padding: 1px; font-weight: normal;}
		code {font-size: 12px;}
		.TableObject {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableData {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableHeader {border-color: #000000; text-decoration: bold; background-color: #e0e0e0;}
		.StructureHeader {padding-left: 5px; text-align: left; border-color: #000000; text-decoration: bold;}
		.Structure {text-align: left; border-color: #aaaaaa;}
		.DataHeader {padding-left: 5px; text-align: left; border-color: #000000; background-color: #e0e0e0;}
		.Null {color: #999999;}
		.PrimaryKey {font-weight: bold;}
		.RightAlign {text-align: right;}
	--></style>
</head>
<body>
<h1 class="DatabaseTitle">数据库: ry-vue-v3.8.6</h1>
<h2>表格: gen_table</h2>
<p>备注: 代码生成业务表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="gen_table" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>table_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="gen_table" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">table_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>编号</td>	</tr>
	<tr class="Structure"><td>table_name</td><td>varchar(200)</td><td>是</td><td></td><td>&nbsp;</td><td>表名称</td>	</tr>
	<tr class="Structure"><td>table_comment</td><td>varchar(500)</td><td>是</td><td></td><td>&nbsp;</td><td>表描述</td>	</tr>
	<tr class="Structure"><td>sub_table_name</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>关联子表的表名</td>	</tr>
	<tr class="Structure"><td>sub_table_fk_name</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>子表关联的外键名</td>	</tr>
	<tr class="Structure"><td>class_name</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>实体类名称</td>	</tr>
	<tr class="Structure"><td>tpl_category</td><td>varchar(200)</td><td>是</td><td>crud</td><td>&nbsp;</td><td>使用的模板（crud单表操作 tree树表操作）</td>	</tr>
	<tr class="Structure"><td>package_name</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>生成包路径</td>	</tr>
	<tr class="Structure"><td>module_name</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>生成模块名</td>	</tr>
	<tr class="Structure"><td>business_name</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>生成业务名</td>	</tr>
	<tr class="Structure"><td>function_name</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>生成功能名</td>	</tr>
	<tr class="Structure"><td>function_author</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>生成功能作者</td>	</tr>
	<tr class="Structure"><td>gen_type</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>生成代码方式（0zip压缩包 1自定义路径）</td>	</tr>
	<tr class="Structure"><td>gen_path</td><td>varchar(200)</td><td>是</td><td>/</td><td>&nbsp;</td><td>生成路径（不填默认项目路径）</td>	</tr>
	<tr class="Structure"><td>options</td><td>varchar(1000)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>其它生成选项</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: gen_table_column</h2>
<p>备注: 代码生成业务表字段</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="gen_table_column" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>column_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="gen_table_column" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">column_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>编号</td>	</tr>
	<tr class="Structure"><td>table_id</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>归属表编号</td>	</tr>
	<tr class="Structure"><td>column_name</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>列名称</td>	</tr>
	<tr class="Structure"><td>column_comment</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>列描述</td>	</tr>
	<tr class="Structure"><td>column_type</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>列类型</td>	</tr>
	<tr class="Structure"><td>java_type</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>JAVA类型</td>	</tr>
	<tr class="Structure"><td>java_field</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>JAVA字段名</td>	</tr>
	<tr class="Structure"><td>is_pk</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否主键（1是）</td>	</tr>
	<tr class="Structure"><td>is_increment</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否自增（1是）</td>	</tr>
	<tr class="Structure"><td>is_required</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否必填（1是）</td>	</tr>
	<tr class="Structure"><td>is_insert</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否为插入字段（1是）</td>	</tr>
	<tr class="Structure"><td>is_edit</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否编辑字段（1是）</td>	</tr>
	<tr class="Structure"><td>is_list</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否列表字段（1是）</td>	</tr>
	<tr class="Structure"><td>is_query</td><td>char(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否查询字段（1是）</td>	</tr>
	<tr class="Structure"><td>query_type</td><td>varchar(200)</td><td>是</td><td>EQ</td><td>&nbsp;</td><td>查询方式（等于、不等于、大于、小于、范围）</td>	</tr>
	<tr class="Structure"><td>html_type</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）</td>	</tr>
	<tr class="Structure"><td>dict_type</td><td>varchar(200)</td><td>是</td><td></td><td>&nbsp;</td><td>字典类型</td>	</tr>
	<tr class="Structure"><td>sort</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
</table><br>
<h2>表格: qrtz_blob_triggers</h2>
<p>备注: Blob类型的触发器表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_blob_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, trigger_name, trigger_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_blob_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_name的外键</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_group的外键</td>	</tr>
	<tr class="Structure"><td>blob_data</td><td>blob</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>存放持久化Trigger对象</td>	</tr>
</table><br>
<h3>外键:</h3>
<table border="0" cellspacing="0" summary="qrtz_blob_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th></tr>
	<tr><th>qrtz_blob_triggers_ibfk_1</th><td>(sched_name, trigger_name, trigger_group) -&gt; qrtz_triggers.(sched_name, trigger_name, trigger_group)</td><td></td></tr>
</table><br>
<h2>表格: qrtz_calendars</h2>
<p>备注: 日历信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_calendars" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, calendar_name</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_calendars" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">calendar_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>日历名称</td>	</tr>
	<tr class="Structure"><td>calendar</td><td>blob</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>存放持久化calendar对象</td>	</tr>
</table><br>
<h2>表格: qrtz_cron_triggers</h2>
<p>备注: Cron类型的触发器表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_cron_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, trigger_name, trigger_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_cron_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_name的外键</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_group的外键</td>	</tr>
	<tr class="Structure"><td>cron_expression</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>cron表达式</td>	</tr>
	<tr class="Structure"><td>time_zone_id</td><td>varchar(80)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>时区</td>	</tr>
</table><br>
<h3>外键:</h3>
<table border="0" cellspacing="0" summary="qrtz_cron_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th></tr>
	<tr><th>qrtz_cron_triggers_ibfk_1</th><td>(sched_name, trigger_name, trigger_group) -&gt; qrtz_triggers.(sched_name, trigger_name, trigger_group)</td><td></td></tr>
</table><br>
<h2>表格: qrtz_fired_triggers</h2>
<p>备注: 已触发的触发器表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_fired_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, entry_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_fired_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">entry_id</td><td>varchar(95)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度器实例id</td>	</tr>
	<tr class="Structure"><td>trigger_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_name的外键</td>	</tr>
	<tr class="Structure"><td>trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_group的外键</td>	</tr>
	<tr class="Structure"><td>instance_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度器实例名</td>	</tr>
	<tr class="Structure"><td>fired_time</td><td>bigint(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>触发的时间</td>	</tr>
	<tr class="Structure"><td>sched_time</td><td>bigint(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>定时器制定的时间</td>	</tr>
	<tr class="Structure"><td>priority</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>优先级</td>	</tr>
	<tr class="Structure"><td>state</td><td>varchar(16)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>状态</td>	</tr>
	<tr class="Structure"><td>job_name</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>任务名称</td>	</tr>
	<tr class="Structure"><td>job_group</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>任务组名</td>	</tr>
	<tr class="Structure"><td>is_nonconcurrent</td><td>varchar(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否并发</td>	</tr>
	<tr class="Structure"><td>requests_recovery</td><td>varchar(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>是否接受恢复执行</td>	</tr>
</table><br>
<h2>表格: qrtz_job_details</h2>
<p>备注: 任务详细信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_job_details" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, job_name, job_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_job_details" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">job_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>任务名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">job_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>任务组名</td>	</tr>
	<tr class="Structure"><td>description</td><td>varchar(250)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>相关介绍</td>	</tr>
	<tr class="Structure"><td>job_class_name</td><td>varchar(250)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>执行任务类名称</td>	</tr>
	<tr class="Structure"><td>is_durable</td><td>varchar(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>是否持久化</td>	</tr>
	<tr class="Structure"><td>is_nonconcurrent</td><td>varchar(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>是否并发</td>	</tr>
	<tr class="Structure"><td>is_update_data</td><td>varchar(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>是否更新数据</td>	</tr>
	<tr class="Structure"><td>requests_recovery</td><td>varchar(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>是否接受恢复执行</td>	</tr>
	<tr class="Structure"><td>job_data</td><td>blob</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>存放持久化job对象</td>	</tr>
</table><br>
<h2>表格: qrtz_locks</h2>
<p>备注: 存储的悲观锁信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_locks" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, lock_name</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_locks" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">lock_name</td><td>varchar(40)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>悲观锁名称</td>	</tr>
</table><br>
<h2>表格: qrtz_paused_trigger_grps</h2>
<p>备注: 暂停的触发器表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_paused_trigger_grps" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, trigger_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_paused_trigger_grps" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_group的外键</td>	</tr>
</table><br>
<h2>表格: qrtz_scheduler_state</h2>
<p>备注: 调度器状态表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_scheduler_state" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, instance_name</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_scheduler_state" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">instance_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>实例名称</td>	</tr>
	<tr class="Structure"><td>last_checkin_time</td><td>bigint(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>上次检查时间</td>	</tr>
	<tr class="Structure"><td>checkin_interval</td><td>bigint(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>检查间隔时间</td>	</tr>
</table><br>
<h2>表格: qrtz_simple_triggers</h2>
<p>备注: 简单触发器的信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_simple_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, trigger_name, trigger_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_simple_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_name的外键</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_group的外键</td>	</tr>
	<tr class="Structure"><td>repeat_count</td><td>bigint(7)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>重复的次数统计</td>	</tr>
	<tr class="Structure"><td>repeat_interval</td><td>bigint(12)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>重复的间隔时间</td>	</tr>
	<tr class="Structure"><td>times_triggered</td><td>bigint(10)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>已经触发的次数</td>	</tr>
</table><br>
<h3>外键:</h3>
<table border="0" cellspacing="0" summary="qrtz_simple_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th></tr>
	<tr><th>qrtz_simple_triggers_ibfk_1</th><td>(sched_name, trigger_name, trigger_group) -&gt; qrtz_triggers.(sched_name, trigger_name, trigger_group)</td><td></td></tr>
</table><br>
<h2>表格: qrtz_simprop_triggers</h2>
<p>备注: 同步机制的行锁表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_simprop_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, trigger_name, trigger_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_simprop_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_name的外键</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_triggers表trigger_group的外键</td>	</tr>
	<tr class="Structure"><td>str_prop_1</td><td>varchar(512)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>String类型的trigger的第一个参数</td>	</tr>
	<tr class="Structure"><td>str_prop_2</td><td>varchar(512)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>String类型的trigger的第二个参数</td>	</tr>
	<tr class="Structure"><td>str_prop_3</td><td>varchar(512)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>String类型的trigger的第三个参数</td>	</tr>
	<tr class="Structure"><td>int_prop_1</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>int类型的trigger的第一个参数</td>	</tr>
	<tr class="Structure"><td>int_prop_2</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>int类型的trigger的第二个参数</td>	</tr>
	<tr class="Structure"><td>long_prop_1</td><td>bigint(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>long类型的trigger的第一个参数</td>	</tr>
	<tr class="Structure"><td>long_prop_2</td><td>bigint(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>long类型的trigger的第二个参数</td>	</tr>
	<tr class="Structure"><td>dec_prop_1</td><td>numeric(13,4)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>decimal类型的trigger的第一个参数</td>	</tr>
	<tr class="Structure"><td>dec_prop_2</td><td>numeric(13,4)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>decimal类型的trigger的第二个参数</td>	</tr>
	<tr class="Structure"><td>bool_prop_1</td><td>varchar(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>Boolean类型的trigger的第一个参数</td>	</tr>
	<tr class="Structure"><td>bool_prop_2</td><td>varchar(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>Boolean类型的trigger的第二个参数</td>	</tr>
</table><br>
<h3>外键:</h3>
<table border="0" cellspacing="0" summary="qrtz_simprop_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th></tr>
	<tr><th>qrtz_simprop_triggers_ibfk_1</th><td>(sched_name, trigger_name, trigger_group) -&gt; qrtz_triggers.(sched_name, trigger_name, trigger_group)</td><td></td></tr>
</table><br>
<h2>表格: qrtz_triggers</h2>
<p>备注: 触发器详细信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="qrtz_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>sched_name, trigger_name, trigger_group</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >sched_name</td><td>sched_name, job_name, job_group</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="qrtz_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">sched_name</td><td>varchar(120)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调度名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>触发器的名字</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">trigger_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>触发器所属组的名字</td>	</tr>
	<tr class="Structure"><td>job_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_job_details表job_name的外键</td>	</tr>
	<tr class="Structure"><td>job_group</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qrtz_job_details表job_group的外键</td>	</tr>
	<tr class="Structure"><td>description</td><td>varchar(250)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>相关介绍</td>	</tr>
	<tr class="Structure"><td>next_fire_time</td><td>bigint(13)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>上一次触发时间（毫秒）</td>	</tr>
	<tr class="Structure"><td>prev_fire_time</td><td>bigint(13)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>下一次触发时间（默认为-1表示不触发）</td>	</tr>
	<tr class="Structure"><td>priority</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>优先级</td>	</tr>
	<tr class="Structure"><td>trigger_state</td><td>varchar(16)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>触发器状态</td>	</tr>
	<tr class="Structure"><td>trigger_type</td><td>varchar(8)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>触发器的类型</td>	</tr>
	<tr class="Structure"><td>start_time</td><td>bigint(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>开始时间</td>	</tr>
	<tr class="Structure"><td>end_time</td><td>bigint(13)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>结束时间</td>	</tr>
	<tr class="Structure"><td>calendar_name</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>日程表名称</td>	</tr>
	<tr class="Structure"><td>misfire_instr</td><td>smallint(2)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>补偿执行的策略</td>	</tr>
	<tr class="Structure"><td>job_data</td><td>blob</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>存放持久化job对象</td>	</tr>
</table><br>
<h3>外键:</h3>
<table border="0" cellspacing="0" summary="qrtz_triggers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th></tr>
	<tr><th>qrtz_triggers_ibfk_1</th><td>(sched_name, job_name, job_group) -&gt; qrtz_job_details.(sched_name, job_name, job_group)</td><td></td></tr>
</table><br>
<h2>表格: sys_config</h2>
<p>备注: 参数配置表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_config" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>config_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_config" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">config_id</td><td>int(5)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>参数主键</td>	</tr>
	<tr class="Structure"><td>config_name</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>参数名称</td>	</tr>
	<tr class="Structure"><td>config_key</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>参数键名</td>	</tr>
	<tr class="Structure"><td>config_value</td><td>varchar(500)</td><td>是</td><td></td><td>&nbsp;</td><td>参数键值</td>	</tr>
	<tr class="Structure"><td>config_type</td><td>char(1)</td><td>是</td><td>N</td><td>&nbsp;</td><td>系统内置（Y是 N否）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_dept</h2>
<p>备注: 部门表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_dept" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>dept_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_dept" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">dept_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>部门id</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>bigint(20)</td><td>是</td><td>0</td><td>&nbsp;</td><td>父部门id</td>	</tr>
	<tr class="Structure"><td>ancestors</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>祖级列表</td>	</tr>
	<tr class="Structure"><td>dept_name</td><td>varchar(30)</td><td>是</td><td></td><td>&nbsp;</td><td>部门名称</td>	</tr>
	<tr class="Structure"><td>order_num</td><td>int(4)</td><td>是</td><td>0</td><td>&nbsp;</td><td>显示顺序</td>	</tr>
	<tr class="Structure"><td>leader</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>负责人</td>	</tr>
	<tr class="Structure"><td>phone</td><td>varchar(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>联系电话</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>邮箱</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>部门状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>del_flag</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>删除标志（0代表存在 2代表删除）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
</table><br>
<h2>表格: sys_dict_data</h2>
<p>备注: 字典数据表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_dict_data" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>dict_code</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_dict_data" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">dict_code</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>字典编码</td>	</tr>
	<tr class="Structure"><td>dict_sort</td><td>int(4)</td><td>是</td><td>0</td><td>&nbsp;</td><td>字典排序</td>	</tr>
	<tr class="Structure"><td>dict_label</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>字典标签</td>	</tr>
	<tr class="Structure"><td>dict_value</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>字典键值</td>	</tr>
	<tr class="Structure"><td>dict_type</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>字典类型</td>	</tr>
	<tr class="Structure"><td>css_class</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>样式属性（其他样式扩展）</td>	</tr>
	<tr class="Structure"><td>list_class</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>表格回显样式</td>	</tr>
	<tr class="Structure"><td>is_default</td><td>char(1)</td><td>是</td><td>N</td><td>&nbsp;</td><td>是否默认（Y是 N否）</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_dict_type</h2>
<p>备注: 字典类型表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_dict_type" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>dict_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >dict_type</td><td>dict_type</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_dict_type" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">dict_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>字典主键</td>	</tr>
	<tr class="Structure"><td>dict_name</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>字典名称</td>	</tr>
	<tr class="Structure"><td>dict_type</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>字典类型</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_job</h2>
<p>备注: 定时任务调度表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_job" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>job_id, job_name, job_group</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_job" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">job_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>任务ID</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">job_name</td><td>varchar(64)</td><td>否</td><td></td><td>&nbsp;</td><td>任务名称</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">job_group</td><td>varchar(64)</td><td>否</td><td>DEFAULT</td><td>&nbsp;</td><td>任务组名</td>	</tr>
	<tr class="Structure"><td>invoke_target</td><td>varchar(500)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调用目标字符串</td>	</tr>
	<tr class="Structure"><td>cron_expression</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>cron执行表达式</td>	</tr>
	<tr class="Structure"><td>misfire_policy</td><td>varchar(20)</td><td>是</td><td>3</td><td>&nbsp;</td><td>计划执行错误策略（1立即执行 2执行一次 3放弃执行）</td>	</tr>
	<tr class="Structure"><td>concurrent</td><td>char(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否并发执行（0允许 1禁止）</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>状态（0正常 1暂停）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td></td><td>&nbsp;</td><td>备注信息</td>	</tr>
</table><br>
<h2>表格: sys_job_log</h2>
<p>备注: 定时任务调度日志表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_job_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>job_log_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_job_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">job_log_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>任务日志ID</td>	</tr>
	<tr class="Structure"><td>job_name</td><td>varchar(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>任务名称</td>	</tr>
	<tr class="Structure"><td>job_group</td><td>varchar(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>任务组名</td>	</tr>
	<tr class="Structure"><td>invoke_target</td><td>varchar(500)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>调用目标字符串</td>	</tr>
	<tr class="Structure"><td>job_message</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>日志信息</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>执行状态（0正常 1失败）</td>	</tr>
	<tr class="Structure"><td>exception_info</td><td>varchar(2000)</td><td>是</td><td></td><td>&nbsp;</td><td>异常信息</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
</table><br>
<h2>表格: sys_logininfor</h2>
<p>备注: 系统访问记录</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_logininfor" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>info_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >idx_sys_logininfor_lt</td><td>login_time</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >idx_sys_logininfor_s</td><td>status</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_logininfor" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">info_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>访问ID</td>	</tr>
	<tr class="Structure"><td>user_name</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>用户账号</td>	</tr>
	<tr class="Structure"><td>ipaddr</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>登录IP地址</td>	</tr>
	<tr class="Structure"><td>login_location</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>登录地点</td>	</tr>
	<tr class="Structure"><td>browser</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>浏览器类型</td>	</tr>
	<tr class="Structure"><td>os</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>操作系统</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>登录状态（0成功 1失败）</td>	</tr>
	<tr class="Structure"><td>msg</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>提示消息</td>	</tr>
	<tr class="Structure"><td>login_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>访问时间</td>	</tr>
</table><br>
<h2>表格: sys_menu</h2>
<p>备注: 菜单权限表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>menu_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">menu_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>菜单ID</td>	</tr>
	<tr class="Structure"><td>menu_name</td><td>varchar(50)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>菜单名称</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>bigint(20)</td><td>是</td><td>0</td><td>&nbsp;</td><td>父菜单ID</td>	</tr>
	<tr class="Structure"><td>order_num</td><td>int(4)</td><td>是</td><td>0</td><td>&nbsp;</td><td>显示顺序</td>	</tr>
	<tr class="Structure"><td>path</td><td>varchar(200)</td><td>是</td><td></td><td>&nbsp;</td><td>路由地址</td>	</tr>
	<tr class="Structure"><td>component</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>组件路径</td>	</tr>
	<tr class="Structure"><td>query</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>路由参数</td>	</tr>
	<tr class="Structure"><td>is_frame</td><td>int(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否为外链（0是 1否）</td>	</tr>
	<tr class="Structure"><td>is_cache</td><td>int(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否缓存（0缓存 1不缓存）</td>	</tr>
	<tr class="Structure"><td>menu_type</td><td>char(1)</td><td>是</td><td></td><td>&nbsp;</td><td>菜单类型（M目录 C菜单 F按钮）</td>	</tr>
	<tr class="Structure"><td>visible</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>菜单状态（0显示 1隐藏）</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>菜单状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>perms</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>权限标识</td>	</tr>
	<tr class="Structure"><td>icon</td><td>varchar(100)</td><td>是</td><td>#</td><td>&nbsp;</td><td>菜单图标</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td></td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_notice</h2>
<p>备注: 通知公告表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_notice" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>notice_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_notice" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">notice_id</td><td>int(4)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>公告ID</td>	</tr>
	<tr class="Structure"><td>notice_title</td><td>varchar(50)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>公告标题</td>	</tr>
	<tr class="Structure"><td>notice_type</td><td>char(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>公告类型（1通知 2公告）</td>	</tr>
	<tr class="Structure"><td>notice_content</td><td>longblob</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>公告内容</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>公告状态（0正常 1关闭）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_oper_log</h2>
<p>备注: 操作日志记录</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_oper_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>oper_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >idx_sys_oper_log_bt</td><td>business_type</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >idx_sys_oper_log_ot</td><td>oper_time</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >idx_sys_oper_log_s</td><td>status</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_oper_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">oper_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>日志主键</td>	</tr>
	<tr class="Structure"><td>title</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>模块标题</td>	</tr>
	<tr class="Structure"><td>business_type</td><td>int(2)</td><td>是</td><td>0</td><td>&nbsp;</td><td>业务类型（0其它 1新增 2修改 3删除）</td>	</tr>
	<tr class="Structure"><td>method</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>方法名称</td>	</tr>
	<tr class="Structure"><td>request_method</td><td>varchar(10)</td><td>是</td><td></td><td>&nbsp;</td><td>请求方式</td>	</tr>
	<tr class="Structure"><td>operator_type</td><td>int(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>操作类别（0其它 1后台用户 2手机端用户）</td>	</tr>
	<tr class="Structure"><td>oper_name</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>操作人员</td>	</tr>
	<tr class="Structure"><td>dept_name</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>部门名称</td>	</tr>
	<tr class="Structure"><td>oper_url</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>请求URL</td>	</tr>
	<tr class="Structure"><td>oper_ip</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>主机地址</td>	</tr>
	<tr class="Structure"><td>oper_location</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>操作地点</td>	</tr>
	<tr class="Structure"><td>oper_param</td><td>varchar(2000)</td><td>是</td><td></td><td>&nbsp;</td><td>请求参数</td>	</tr>
	<tr class="Structure"><td>json_result</td><td>varchar(2000)</td><td>是</td><td></td><td>&nbsp;</td><td>返回参数</td>	</tr>
	<tr class="Structure"><td>status</td><td>int(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>操作状态（0正常 1异常）</td>	</tr>
	<tr class="Structure"><td>error_msg</td><td>varchar(2000)</td><td>是</td><td></td><td>&nbsp;</td><td>错误消息</td>	</tr>
	<tr class="Structure"><td>oper_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>操作时间</td>	</tr>
	<tr class="Structure"><td>cost_time</td><td>bigint(20)</td><td>是</td><td>0</td><td>&nbsp;</td><td>消耗时间</td>	</tr>
</table><br>
<h2>表格: sys_post</h2>
<p>备注: 岗位信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_post" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>post_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_post" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">post_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>岗位ID</td>	</tr>
	<tr class="Structure"><td>post_code</td><td>varchar(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>岗位编码</td>	</tr>
	<tr class="Structure"><td>post_name</td><td>varchar(50)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>岗位名称</td>	</tr>
	<tr class="Structure"><td>post_sort</td><td>int(4)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>显示顺序</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_role</h2>
<p>备注: 角色信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_role" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>role_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_role" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">role_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>角色ID</td>	</tr>
	<tr class="Structure"><td>role_name</td><td>varchar(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>角色名称</td>	</tr>
	<tr class="Structure"><td>role_key</td><td>varchar(100)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>角色权限字符串</td>	</tr>
	<tr class="Structure"><td>role_sort</td><td>int(4)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>显示顺序</td>	</tr>
	<tr class="Structure"><td>data_scope</td><td>char(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）</td>	</tr>
	<tr class="Structure"><td>menu_check_strictly</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>菜单树选择项是否关联显示</td>	</tr>
	<tr class="Structure"><td>dept_check_strictly</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>部门树选择项是否关联显示</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>角色状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>del_flag</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>删除标志（0代表存在 2代表删除）</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_role_dept</h2>
<p>备注: 角色和部门关联表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_role_dept" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>role_id, dept_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_role_dept" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">role_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>角色ID</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">dept_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>部门ID</td>	</tr>
</table><br>
<h2>表格: sys_role_menu</h2>
<p>备注: 角色和菜单关联表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_role_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>role_id, menu_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_role_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">role_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>角色ID</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">menu_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>菜单ID</td>	</tr>
</table><br>
<h2>表格: sys_user</h2>
<p>备注: 用户信息表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_user" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>user_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_user" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">user_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>用户ID</td>	</tr>
	<tr class="Structure"><td>dept_id</td><td>bigint(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>部门ID</td>	</tr>
	<tr class="Structure"><td>user_name</td><td>varchar(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户账号</td>	</tr>
	<tr class="Structure"><td>nick_name</td><td>varchar(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户昵称</td>	</tr>
	<tr class="Structure"><td>user_type</td><td>varchar(2)</td><td>是</td><td>00</td><td>&nbsp;</td><td>用户类型（00系统用户）</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(50)</td><td>是</td><td></td><td>&nbsp;</td><td>用户邮箱</td>	</tr>
	<tr class="Structure"><td>phonenumber</td><td>varchar(11)</td><td>是</td><td></td><td>&nbsp;</td><td>手机号码</td>	</tr>
	<tr class="Structure"><td>sex</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>用户性别（0男 1女 2未知）</td>	</tr>
	<tr class="Structure"><td>avatar</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>头像地址</td>	</tr>
	<tr class="Structure"><td>password</td><td>varchar(100)</td><td>是</td><td></td><td>&nbsp;</td><td>密码</td>	</tr>
	<tr class="Structure"><td>status</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>帐号状态（0正常 1停用）</td>	</tr>
	<tr class="Structure"><td>del_flag</td><td>char(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>删除标志（0代表存在 2代表删除）</td>	</tr>
	<tr class="Structure"><td>login_ip</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>最后登录IP</td>	</tr>
	<tr class="Structure"><td>login_date</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>最后登录时间</td>	</tr>
	<tr class="Structure"><td>create_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>创建者</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>update_by</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>更新者</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(500)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>备注</td>	</tr>
</table><br>
<h2>表格: sys_user_post</h2>
<p>备注: 用户与岗位关联表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_user_post" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>user_id, post_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_user_post" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">user_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户ID</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">post_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>岗位ID</td>	</tr>
</table><br>
<h2>表格: sys_user_role</h2>
<p>备注: 用户和角色关联表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="sys_user_role" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>user_id, role_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="sys_user_role" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>其他</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">user_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户ID</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">role_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>角色ID</td>	</tr>
</table><br>
</body>
</html>
